# -*- coding: utf-8 -*-            
# @Time : 2025/6/26 14:04
# @FileName: 01.py
# @Target:
import json, codecs, time, os
from pprint import pprint
import pandas as pd

df = pd.read_excel("ID.UNYX.xlsx")
all_data = []
for row_index, row in df.iterrows():
    feel_1 = row['feel_1']
    feel_2 = row['feel_2']
    content_list = row['content_list']
    sentiment = row['sentiment']
    if isinstance(feel_1, str):
        if len(feel_1):
            all_data.append({
                'feel_1': feel_1,
                'feel_2': feel_2,
                'content_list': content_list,
                'sentiment': sentiment
            })
content_list_set = set()
for d in all_data :
    feel_1 = d['feel_1']
    feel_2 = d['feel_2']
    content_list = d['content_list']
    sentiment = d['sentiment']
    if '座椅' in feel_2 and sentiment.startswith('负向'):
        content_list_set.add(content_list)

content_list_set = list(content_list_set)
content_list_set = "\r\n".join(content_list_set)
print(content_list_set)








